package com.hxzy.dao;

import com.hxzy.pojo.TeaSignIn;
import com.hxzy.pojo.TeacherCoures;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;
import tk.mybatis.mapper.common.MySqlMapper;

import java.util.List;

public interface TeaCouresMapper extends Mapper<TeacherCoures>, MySqlMapper<TeacherCoures> {
    @Select("SELECT  t.tea_name name , SUM(t.count) total,count(zhiban) zhiban,t.select_class FROM tea_sign_in t GROUP BY tea_name,select_class")
    List<TeacherCoures> getAllteachcoure();

}
